UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4pgBMMCxr6lvM5RNbrUg3QAKXg2ddE+zzQGcpdA5QZY='
WHERE
key_id = '9dac0bbdd919273215509563e6879b3830b9866428af52b7cf2b37c0c90ca908'
AND (
token = '4pgBMMCxr6lvM5RNbrUg3QAKXg2ddE+zzQGcpdA5QZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)