UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4HsIhIftgW4otDK0LvF1ZaI1kvmwOwhqrggoiU5B6vE='
WHERE
key_id = 'df5c56ec637e70d07fe7d15bb47c167b380af950906d196fe1257262ea5cc91c'
AND (
token = '4HsIhIftgW4otDK0LvF1ZaI1kvmwOwhqrggoiU5B6vE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)