UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NKpSQxDRadyPRgk1Z1N+BfQoEJxsFaaOkKwjSHRA6Xs='
WHERE
key_id = 'ce2ec5c8e582407feb8a02f899bc79f466b0e94bb7413e20dbcc2ea76d0897f9'
AND (
token = 'NKpSQxDRadyPRgk1Z1N+BfQoEJxsFaaOkKwjSHRA6Xs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)