UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CyQSsYtu2eaejt+5GM4CCZO0zlnq2fSOasYD6g8fLMc='
WHERE
key_id = 'cba3a2885578c846a01fd8a73a196d8ee56e3fe7e32342a1f49f0212902976bb'
AND (
token = 'CyQSsYtu2eaejt+5GM4CCZO0zlnq2fSOasYD6g8fLMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)