UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xw1S+o4siX/QNy68WijGq/MH3wkIzpzvJ196aIDa+ik='
WHERE
key_id = '4ddb77f20f16d10fc1d152d7e03dd74af04b9be21b954cbbce0cfb6c5df28529'
AND (
token = 'Xw1S+o4siX/QNy68WijGq/MH3wkIzpzvJ196aIDa+ik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)