UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OeYGWevCi25HGF3yBwzI0GjTL/b8gNEjdmc93Qr8O7w='
WHERE
key_id = 'c0383fdf7b99b3ceb9c632fb7e78cec25a24c74ba69f3e8a00f539bd889f6115'
AND (
token = 'OeYGWevCi25HGF3yBwzI0GjTL/b8gNEjdmc93Qr8O7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)