UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cx54as5DHa1TSTKyIIlRJDLznykv9yIuEeKndbOvHNw='
WHERE
key_id = '1b15489af0208b7aacc08c601125f4c63e6f2ffc2aa23c7e3bf5f4f4f40f9607'
AND (
token = 'cx54as5DHa1TSTKyIIlRJDLznykv9yIuEeKndbOvHNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)