UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Snt8w9dnMEjiWo7iMksixFHpxfw77/x6O6U9dngBfGs='
WHERE
key_id = '786728a35f05095b9e0638bd2e0b826d4eb2b66fcb6838cd548b4484bef488c8'
AND (
token = 'Snt8w9dnMEjiWo7iMksixFHpxfw77/x6O6U9dngBfGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)