UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7aKh4grctmdu+tgjt5tFKXD9NnlFPPTK/we1g80G+dw='
WHERE
key_id = 'b0de90bd3261c0a9f1507cae6705dc9fc82dc01e0d499a3fd93066be9e0eb861'
AND (
token = '7aKh4grctmdu+tgjt5tFKXD9NnlFPPTK/we1g80G+dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)