UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QY6U/91MsHbfUu7otqwwk3y3LgD76nyCoZF5RVlgthQ='
WHERE
key_id = 'e2dcf987d0092cc4a697ade957b56b8638e319649edd02fee83397b1b647b0bb'
AND (
token = 'QY6U/91MsHbfUu7otqwwk3y3LgD76nyCoZF5RVlgthQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)