UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdEzG+uoBpkqbosbgKpln8pbAyX6BWG/nW5YsvzxuDI='
WHERE
key_id = 'd8b6aa92018c2cec33c060578b856c876ee0edfaed0d3872af632ef8e08a307b'
AND (
token = 'XdEzG+uoBpkqbosbgKpln8pbAyX6BWG/nW5YsvzxuDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)