UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPJzyP9yoag7bIMhAMvmqXhwTnpTTH68fP23FbkTPbk='
WHERE
key_id = '593f93ad8a2e87228ac2880a052ed05f0a77f04180358a3810db9a02973901cf'
AND (
token = 'sPJzyP9yoag7bIMhAMvmqXhwTnpTTH68fP23FbkTPbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)