UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgFPzWwTyoW4YQM9JrC9krhlY3vQ67Cp/CuMP8DczUM='
WHERE
key_id = '8b923334d02e6c1562ac7084edf4555f7351adf1e10e0460b75c60a7fa869988'
AND (
token = 'XgFPzWwTyoW4YQM9JrC9krhlY3vQ67Cp/CuMP8DczUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)