UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sl5pncXVvh8PW7Fer5OnDx0HYqRfbEaJV4R9C3XeMdU='
WHERE
key_id = '4176b857ca294e50f0833d79467402321e6481d28c2f010b3098ff7791f5a96b'
AND (
token = 'Sl5pncXVvh8PW7Fer5OnDx0HYqRfbEaJV4R9C3XeMdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)