UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCoMSUl6QcsdLmWtc7AY+JXxbsY3Edy2bhIKPRMg7eg='
WHERE
key_id = '54ae98b857eb15eec17ab03214ed43035f47f1743dbc7ddca94a5d61e160c55c'
AND (
token = 'hCoMSUl6QcsdLmWtc7AY+JXxbsY3Edy2bhIKPRMg7eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)