UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z/rQ/2peIbC3wRwMqeHBMPt5bT9pw0yw2vsVmuzd0U4='
WHERE
key_id = 'bc70a53babd0c8bd24eacf106c98e29c49d7c74dc45ed4e4743817b3aa04508b'
AND (
token = 'Z/rQ/2peIbC3wRwMqeHBMPt5bT9pw0yw2vsVmuzd0U4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)