UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PJb32ROJOhA17AZGhmIIlnkuQjwDatnk1i374t/u0KI='
WHERE
key_id = 'a200b7815f0a8c4a83da3f6aafb40a8557b33f445086a7201c642ff614bd062f'
AND (
token = 'PJb32ROJOhA17AZGhmIIlnkuQjwDatnk1i374t/u0KI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)