UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ALBRf9oUNkI59EPGTWjG7R91uwtZExzSS0XNH8Cwzj0='
WHERE
key_id = 'bdafdb1d601ec013bbc3e0f16af26cea44327bd28698cc843f801704c699ff7a'
AND (
token = 'ALBRf9oUNkI59EPGTWjG7R91uwtZExzSS0XNH8Cwzj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)