UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qptPHwXdGD/0FaEa6joYxS1bsUIjNL6Suavw2saf88s='
WHERE
key_id = 'cc3ce763de225ac7b1bc176f692ae5781f2eb9a549991d3fca58c622fb415400'
AND (
token = 'qptPHwXdGD/0FaEa6joYxS1bsUIjNL6Suavw2saf88s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)