UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIFMyIXhXsLceWgUx3+gqcT+aziuqmj1o/p6ZLAtyGI='
WHERE
key_id = '9382696d2e69a9a67731627ff5111cbe1e4b019da391504064b9eede3330ace0'
AND (
token = 'gIFMyIXhXsLceWgUx3+gqcT+aziuqmj1o/p6ZLAtyGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)