UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M3cGFNMMzGxqvTxiZBGwb4VHhd10ZFWw2fIVDMEack8='
WHERE
key_id = '8c99def6d8c6b97563b8550dbea7ec8412373b59d97cb2285360b9db1453d94f'
AND (
token = 'M3cGFNMMzGxqvTxiZBGwb4VHhd10ZFWw2fIVDMEack8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)