UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJaV87znElDXOYZNt0uA2NNiKfgUJf2iAKBvoiTae4Q='
WHERE
key_id = '522102017376b12fd83ad1455a71cd44d39a389326fdc1c764b9e8c45539bbb3'
AND (
token = 'zJaV87znElDXOYZNt0uA2NNiKfgUJf2iAKBvoiTae4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)