UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qhXyWc50UiPknGiaYUVqUBvihHezVn7spW032ur00dE='
WHERE
key_id = 'b8ed42c611e2f1950f711cf8cc7f5a0a29d5e79a7380afd26cb28e0aeb6b84b4'
AND (
token = 'qhXyWc50UiPknGiaYUVqUBvihHezVn7spW032ur00dE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)