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