UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZW7RREm5DGOsF38B4KFv3QY7wk95VcNDqgcBn86enGw='
WHERE
key_id = '693a21b52f36925fce864612cbab2e0df4f6762b22dab27f32e42e420ecf4599'
AND (
token = 'ZW7RREm5DGOsF38B4KFv3QY7wk95VcNDqgcBn86enGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)