UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vP/YEsO8HWlMdV0MQxOfyTbKkRwBNrl69O1wVM9WBuA='
WHERE
key_id = 'd681307ad67e58399b6d6d48d26aff6a2be7e4f431f0a4873af3b09b096a4ebf'
AND (
token = 'vP/YEsO8HWlMdV0MQxOfyTbKkRwBNrl69O1wVM9WBuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)