UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vpkgYD8l+/CxoTmdXdNbvxMs7eH5awz9BPI0uEHgggo='
WHERE
key_id = '678f9fb15fe71640eb9b04e3a3c5a40c29687a799965908f4c1435bd39517cd3'
AND (
token = 'vpkgYD8l+/CxoTmdXdNbvxMs7eH5awz9BPI0uEHgggo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)