UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IxRPkQKNg8Rz4F2pI8WutVANycRXNA07CaQtlvAUYcc='
WHERE
key_id = '55cf8653d0acbe7b0ae9b43ff46cd70a6beace4a1dfc1c02587a09063a150e89'
AND (
token = 'IxRPkQKNg8Rz4F2pI8WutVANycRXNA07CaQtlvAUYcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)