UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qnyg3EP57cUvOugVJulBV/iuh51UfkIwbGIMU6QQmsU='
WHERE
key_id = 'fdd72917860c1d11537b68495b09f9b29ef1e32c6c91ab14b68047c71c8ad0f0'
AND (
token = 'Qnyg3EP57cUvOugVJulBV/iuh51UfkIwbGIMU6QQmsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)