UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zEtS0H9x4dFdbCmc69HLVEi9LfXUC+Ex71Pr3C+rYu0='
WHERE
key_id = 'f9bbff6f12eeda0ce68e38e6bfea6c423b989270987d1f08264b824eb8ce9326'
AND (
token = 'zEtS0H9x4dFdbCmc69HLVEi9LfXUC+Ex71Pr3C+rYu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)