UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Osjb7g+LQ52AfZUkxvAiqBAtf20kBNhuHFXEyB/dCsM='
WHERE
key_id = 'b0605a47633d3de38762ca3e808a0efbebf6802bc1a265f24574b7ba96fee1bd'
AND (
token = 'Osjb7g+LQ52AfZUkxvAiqBAtf20kBNhuHFXEyB/dCsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)