UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tFKJuI/S1DdYt6yMHRbOGUcYHioFkPT3AZx0F66X2tk='
WHERE
key_id = 'ddd78e213662055c72433fed3324dda0e84b5de19736776e855f9d3f610a89ea'
AND (
token = 'tFKJuI/S1DdYt6yMHRbOGUcYHioFkPT3AZx0F66X2tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)