UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CTPN9xOeIKxFQ4xkOVgT2gFUQoM6tiWzzjiIZszMvL4='
WHERE
key_id = '09ab24484e84d8e18bacb8e8e97a134b54c7f2f53eaf5495dee36b0c1aeda4a4'
AND (
token = 'CTPN9xOeIKxFQ4xkOVgT2gFUQoM6tiWzzjiIZszMvL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)