UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mxBIYojcS6B5aJ6VGuLvmfLFeyYjY3xFK4ZUN7LuSKU='
WHERE
key_id = '7cd2f26429a331fba1bac847c52eb63a6a828153b84efe6e25528dca1044be11'
AND (
token = 'mxBIYojcS6B5aJ6VGuLvmfLFeyYjY3xFK4ZUN7LuSKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)