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