UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zm5jJwjIAa6/AjaVwT6XAFoe4I+4D7OcekayVF7owUY='
WHERE
key_id = '5e9bc78096353e23a01ba9b133003561076d7b45ed35287fad8cda54c5536a4f'
AND (
token = 'zm5jJwjIAa6/AjaVwT6XAFoe4I+4D7OcekayVF7owUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)