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