UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiiOoxZm8yCyORsyIvjx1YN95oBBd9XTxjXVnTyNd4w='
WHERE
key_id = 'b57bf52b86cf91a69b4e05ebbce69a65a38cf8de6a866be7118b2ff76b36d59d'
AND (
token = 'qiiOoxZm8yCyORsyIvjx1YN95oBBd9XTxjXVnTyNd4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)