UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FNQuNfKEvpJDsjDiqsAFAD1QsEzqPJi4Dn9wfAw06HU='
WHERE
key_id = 'b82d6f4bd311c4ed12647b8938a04bf6a5e7ded0f7f5d4e80ad5390b1d3e0dec'
AND (
token = 'FNQuNfKEvpJDsjDiqsAFAD1QsEzqPJi4Dn9wfAw06HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)