UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BNoE6zg6BJ5PV3P2QM1FqpQPbMa1hNo2cXj3xPdJRjU='
WHERE
key_id = '3dc70e65ec1cc576c195ad9cd1d8deedb0bfd092cfce0b6ae0e86b1b9551a75d'
AND (
token = 'BNoE6zg6BJ5PV3P2QM1FqpQPbMa1hNo2cXj3xPdJRjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)