UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cH+HRFzAL0x7uTOrsxTh8/iLGZ6VxMczfUBq8K+LTHU='
WHERE
key_id = '278387e89a4b5aa5306b7779495ff84251d48e7171d6e7ab9fe2865d89709533'
AND (
token = 'cH+HRFzAL0x7uTOrsxTh8/iLGZ6VxMczfUBq8K+LTHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)