UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TXz/3q5ydXCNgSIS+yvCRYcKcE/K5RiEaT9+7rMGBy8='
WHERE
key_id = 'a1452c48534b300f5ad994d6f726153be25f862d989fde26d885e67a7a1c2023'
AND (
token = 'TXz/3q5ydXCNgSIS+yvCRYcKcE/K5RiEaT9+7rMGBy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)