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