UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qrHBk0CvfjvLaVEjH5GS4wCLuQVws3HTc8BnA8lV1eo='
WHERE
key_id = '3d1c5078c726f3160e3a3ff5c6eef22a79a24c23baadc16015f4243b191bc35b'
AND (
token = 'qrHBk0CvfjvLaVEjH5GS4wCLuQVws3HTc8BnA8lV1eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)